Microsoft Office Step by Step (Office 2021 and Microsoft 365) by Joan Lambert & Curtis Frye

Author:Joan Lambert & Curtis Frye [Joan Lambert]
Language: eng
Format: epub
ISBN: 9780137544936
Publisher: Microsoft Press
Published: 2022-06-02T00:00:00+00:00

Clear the previous filter, and then create a filter that shows exceptions for the Northeast and Northwest centers.

With the filter still in place, create a second filter that displays only those exceptions that occurred in the month of April.

Clear the filter that shows values related to the Northeast and Northwest centers.

Turn off filtering for the list of data.

Summarize filtered data

Open the SummarizeValues workbook in Excel, and then perform the following tasks:

Combine the IF and RAND functions into formulas in cells H3:H27 that display TRUE if the value is less than 0.3 and FALSE otherwise.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.